[Resolved] Select -> Where -> Is Found

[Kudose]

Hello all. I have this query which is apart of a search menu thing.

What I need this query to do is:

SELECT my variables FROM makers, inventroy WHERE the maker id IS FOUND IN table inventory.

I know that isnt a realy query, but it explains what I need.

here is what I have so far. Any help would be great!

Thanks!

$distinct_make = "SELECT m.make_id, m.maker, i.year, i.make, i.model, i.trim, i.ext_color ";
$distinct_make .= "FROM ".$prefix."manufacturers as m, ".$prefix."inventory as i";
$distinct_make .= " WHERE m.maker!='Not Available'";

[Sxooter]

Sometimes a simple join will work, if the fields match up:

select * from table1, table2 where table1.make=table2.maker

OR an in clause:

select * from table1 where make in (select maker from table2);

[Kudose]

It works.

$distinct_make = "SELECT make FROM ".$prefix."inventory";
				$distinct_make .= " WHERE make!='0'";				
				if($year && ($year !== "")){ $distinct_make .= " AND year='".$year."'"; }
				if($make && ($make !== "")){ $distinct_make .= " AND make='".$make."'"; }
				if($model && ($model !== "")){ $distinct_make .= " AND model='".$model."'"; }
				if($trim && ($trim !== "")){ $distinct_make .= " AND trim='".$trim."'"; }
				if($color && ($color !== "")){ $distinct_make .= " AND ext_color='".$color."'"; }
				//echo $distinct_make; exit;
				$makes = $myDb->dbFetch($distinct_make);
				echo "<select name=\"make\" onChange=\"inventory.submit();\">";
				echo "<option value=\"\""; if(!$make){ echo " selected"; } echo ">Make</option>";
				foreach($makes as $mak){
				$mak_sql = $myDb->dbFetch("SELECT maker FROM ".$prefix."manufacturers WHERE make_id='".$mak['make']."'");
				$mak = $mak_sql[0]['maker'];
					echo "<option value=\"".$mak."\""; if($mak == $make){ echo " selected"; } echo ">".$mak."</option>";
				}				
				echo "</select>";

[Sxooter]

Sweet! I'm afraid when it comes to MySQLisms I'm not real up to date, so I tend to fall back to in() clauses and such.