helo .....again... quick note, u guys are saints, i learn so much here.
i have a question , lets say i have 2 tables
tbl1 :
id
businessid
product
price

tbl2
busiid
bussinesstitle
email

i wana query all the info, do i use a join or do a double query? i am also abit abit clueless what to do i normalize the tables more, so lets say i add a third table holding just tbl1.id and tblbusiid, do the same search rules apply??

I'm not sure what you want exactly.
Do you want to select something from tbl1 first and depending on that businessid, select something from tbl2?

If so, you need something like this:

SELECT * FROM `tbl1`,`tbl2` WHERE `tbl1`.id='SOMETHING', `tbl2`.busiid=`tbl1`.businessid

Not sure, for it has been a while since I last used this.

Not sure, for it has been a while since I last used this.

It's right, and for the record, it's a jointed query between the 2 tables.

do i use a join or do a double query?

There is no absolute truth.
Sometime, a big query will work faster if you break it in several smaller parts.
Sometimes, it's better to use a whole lot of joints.
In the end, your db schema will be a big part of the choice of 1 road or the other.

It's what one of my colleagues refer as "galactic joins" .
Ie: you have more then 30 tables joined, and you don't understand where you came from nor where you are headed, and not really sure of what you want to do anymore.

thanks, yeah that answers my question, i just thought there was a specific way to search when searching large tables.

thanks alot