madolia Posted September 4, 2006 Share Posted September 4, 2006 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. Link to comment https://forums.phpfreaks.com/topic/19632-problelm-joining-2-select-queries/ Share on other sites More sharing options...
fenway Posted September 4, 2006 Share Posted September 4, 2006 Combine how? Link to comment https://forums.phpfreaks.com/topic/19632-problelm-joining-2-select-queries/#findComment-85518 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.