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. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 4, 2006 Share Posted September 4, 2006 Combine how? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.