Search the Community
Showing results for tags 'multiple columns'.
Found 2 results
-
I have data similar to below. I am doing a MySQL query and doing a JOIN based on instructor name. I am echoing classes and linking the instructor name to another page with their BIO. All is working great, however I want to use the ID's for something else. How do I differentiate the ID between the Instructors table and the Classes Table without changing the column name in the database? For instance, I want to echo the Instructor ID and then echo the Classes ID, but they are both the same column name in the database and since they are joined, how will that work? Instructors: ID | Instructor | Title | Bio | 1 | Bob Smith | Chef | bob smith is a chef with... | 2 | Jane Doe | Professor | Jane doe is an instructor that... | Classes: ID | Instructor | Class Title | Class Description | 4 | Bob Smith | Baking | this is a baking class where you learn.... | 5 | Jane Doe | Food Safety | Food safety is very important... |
-
Got these tables: Table1 ID USER 1 User1 2 User2 Table2 ID CAR 1 Car1 2 Car2 Table3 ID STREET 1 Street1 2 Street2 If i wanned to display USER and CAR columns from Table1 and Table2, i would write: SELECT USER, CAR FROM Table1, Table2 WHERE Table1.ID = Table2.ID What if i wanned to add a third table (Table3), how does the code change? SELECT USER, CAR, STREET FROM Table1, Table2, Table3 WHERE ........
