Select statement/ this ones easy 1

[awesomeBA]

Ok I am very rusty and under a deadline. I need syntax help with the following Query.

Select *
From SvyDtl
Where SvyDtl.SdPrjnum = ClsdPort.CpPrjNum.

Any and all help is appreciated.

 

[Remou]

Where are you building this? Have you tried the query builder and SQL view?

 

[lespaul]

paste this in the SQL view:

Select *
From SvyDtl S
INNER JOIN ClsdPort C on S.SdPrjnum = C.CpPrjNum


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[awesomeBA]

Thanks Lespaul... Worked like a charm!! Much love!!!