Jump to content


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


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.


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.