QUERY HELP

[Lena]

What's the correct syntax for query if I have 2 joined tables, but I need to select all columns from one table only.

table1-CONTACT1
table2-CONTACT2


I need to select only all columns from CONTACT1 table.

select * from CONTACT1,CONTACT2
where CONTACT1.ACCOUNTNO=CONTACT2.ACCOUNTNO
AND CONTACT2.UDELETE="Y"



THANKS,

LENA

[Lena]

NEVER MIND, I FIGURED IT OUT

select c1.*
from contact1 c1, contact c2
where c1.accountno=c2.accountno
and c2.udelete="y"






------------
Lena at 2/18/2002 8:51:08 AM

What's the correct syntax for query if I have 2 joined tables, but I need to select all columns from one table only.

table1-CONTACT1
table2-CONTACT2


I need to select only all columns from CONTACT1 table.

select * from CONTACT1,CONTACT2
where CONTACT1.ACCOUNTNO=CONTACT2.ACCOUNTNO
AND CONTACT2.UDELETE="Y"



THANKS,

LENA