Guest User

Untitled

a guest
Apr 26th, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. SELECT tableA.Id, tableB.Id FROM tableA JOIN tableB ON (tableA.bId = tableB.Id)
  2.  
  3. while($result = mysql_fetch_array(mysql_query(/Query Above/)){
  4. print $result['tableB.Id'];
  5. }
  6.  
  7. SELECT tableA.Id AS aId, tableB.Id AS bId
  8. FROM tableA
  9. JOIN tableB ON (tableA.bId = tableB.Id)
  10.  
  11. SELECT tableA.*, tableB.* FROM tableA JOIN tableB ON (tableA.bId = tableB.Id)
Add Comment
Please, Sign In to add comment