Jump to content

Archived

This topic is now archived and is closed to further replies.

madolia

Problelm Joining 2 "Select Queries"

Recommended Posts

I've been trying to solve this problem but I can't.

I hv two seperate tables A and B.
TABLE A
[table][tr][td]ID[/td][td]ticketNO[/td][td]ProgramID[/td][td]Approval[/td][/tr]
[tr][td]1[/td][td]41[/td][td]ABC124[/td][td]Approved[/td][/tr]
[tr][td]2[/td][td]41[/td][td]GHJ489[/td][td]Approved[/td][/tr]
[/table]

TABLE B
[table][tr][td]ProgramID[/td][td]Description[/td][td]OwnerID[/td][/tr]
[tr][td]ABC124[/td][td]Swimming[/td][td]N77893987T[/td][/tr]
[tr][td]GHJ489[/td][td]Cycling[/td][td]N35267141H[/td][/tr]
[/table]

I have two select queries which I need to use  cos I have to look up the tables based on the [b]ticketNO[/b] and [b]OwnerID[/b].
1) Select * from TABLE A where ticketNO="41" and ProgramID="ABC124";
2) Select * from TABLE B where ProgramID="ABC124" and OwnerID="N77893987T";

I do not know how to combine this query so that I can retrieve the datas using PHP and use it in my program. NOTE : There can be the same ticketNO with different ProgramID.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.