• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 424
  • Last Modified:

select * from table_a, table_b

i want to give the following command

select * from table_a, table_b
  where   ........

i want the * to be used in such a way in order to include the fields from table_a only .  is it possible? i am using oracle 9i
0
basilhs_s
Asked:
basilhs_s
4 Solutions
 
AllamzCommented:
Basilhs,

if you need to select all items from table_a only so why do you want to keep table_b with you?

select * from table_A inner join Table_b where
table_A.X = table_B.x
where....

where X is the commen row between the 2 tables.

Best Regards,

Mohamed Allam
Senior Software Engineer
0
 
dportasCommented:
SELECT *
FROM table_a
WHERE EXISTS
 (SELECT 1
  FROM table_b
  WHERE  table_a.col =  table_b.col) ;
0
 
duncancummingCommented:
select table_a.* from table_a, table_b
  where   ........

0
 
dzamfirCommented:
select  a.* from table_a ta, table_b tb
  where   ta.col = tb.col;

0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now