SQL Statement

[maha12]

Hello All,

Is there a SQL Statement to filter the following records.

Tab1:
ID PONo PoDate
11 1000 12/05/04
22 2000 12/05/04
33 3000 13/05/04
Tab2
ID PRNo Description
11 PR1 Desc 1
11 PR2 Desc 2
22 P20 Desc 20

Tab1.ID is a primary key and relate to Tab2.ID. I want to filter all PRNos which relate to PONo=1000

Tks
Maha

 

[zemp]

Try something like this,

SELECT Tab1.*, Tab2.*
FROM Tab1 INNER JOIN Tab2 ON Tab1.ID = Tab2.ID
WHERE (PONo = 1000)

zemp