pepelepew1962 Posted June 1, 2011 Share Posted June 1, 2011 Hello, I am trying to combine 2 queries together and am now looking for help. I really do not know how to explain this, but what I need is the 2 queries to be combine and then the information made available. The key that holds this together is Load00 and Kids00. This is a many ( tblKids ) to one ( tblLoad ) and I fully accept that information from the second query is duplicated, that is actually how I need it. Can anyone place these 2 together. // Part 01 $rad2101 = "SELECT tblLoad_Load00, tblLoad_Load19, tblLoad_Load20, tblLoad_Load21, tblKids_Kids00, tblKids_Kids11, tblKids_Kids12, tblKids_Kids13, tblKids_Kids15 FROM tblLoad_Load AS tblLoad_Load JOIN tblKids_Kids AS tblKids_Kids ON (tblLoad_Load00 = tblKids_Kids00)"; // // Part 02 $rad2102 = "SELECT tblKids_Kids00, MIN(tblKids_Kids12) AS MIN02, MAX(tblKids_Kids12) AS MAX02, AVG(tblKids_Kids12) AS AVG02 FROM tblKids_Kids GROUP BY tblKids_Kids00"; // // Part 03 $rad2103 = "???"; // while($row = mysql_fetch_array($rad2103)) { // // $Load00 = $row['tblLoad_Load00']; // Load ID $Load19 = $row['tblLoad_Load19']; $Load20 = $row['tblLoad_Load20']; $Load21 = $row['tblLoad_Load21']; $Kids00 = $row['tblKids_Kids00']; // Kids ID $Kids11 = $row['tblKids_Kids11']; $Kmax02 = $row['MAX(tblKids_Kids12']; // // MOD EDIT: code tags added. Quote Link to comment https://forums.phpfreaks.com/topic/238054-help-with-combining-2-mysql-queries/ Share on other sites More sharing options...
Pikachu2000 Posted June 1, 2011 Share Posted June 1, 2011 When posting code, enclose it within the forum's . . . BBCode tags. Quote Link to comment https://forums.phpfreaks.com/topic/238054-help-with-combining-2-mysql-queries/#findComment-1223331 Share on other sites More sharing options...
fenway Posted June 2, 2011 Share Posted June 2, 2011 Combine how? The results or the conditions? Quote Link to comment https://forums.phpfreaks.com/topic/238054-help-with-combining-2-mysql-queries/#findComment-1224400 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.