I've designed a database and have enter a substantial amount of data into it already but now realize there may have been a better way to accomplish what i need. I don't want to start over, so maybe there's a work around.
I have one database with 13 tables. I'm planning on scripting a PHP interface to query it and realize now that i don't know if i can query certain requests. For instance, the tables are categories of products but the manufacturer's are limited, so the same manufacturer's appear in each of the 13 tables.
One of the queries i'm going to need to do is a search by manufacturer. This can be done by scripting 13 queries, one for each table, but won't allow for sorting of any kind... right (alphabetical, id, etc...) ?
I guess what i need to know is, is it possible to query from multiple tables in the same request? I've tried a few select statements but none have worked... i'm not too savvy in SQL though.
Thanks in advance
I have one database with 13 tables. I'm planning on scripting a PHP interface to query it and realize now that i don't know if i can query certain requests. For instance, the tables are categories of products but the manufacturer's are limited, so the same manufacturer's appear in each of the 13 tables.
One of the queries i'm going to need to do is a search by manufacturer. This can be done by scripting 13 queries, one for each table, but won't allow for sorting of any kind... right (alphabetical, id, etc...) ?
I guess what i need to know is, is it possible to query from multiple tables in the same request? I've tried a few select statements but none have worked... i'm not too savvy in SQL though.
Thanks in advance