SQL Question? Why use UNION? —
Okay I used this SQL Script to join two tables but a certain amount of rows has to be joined with another table, here is how i did it with a join and union operation
Archive for the ‘SQL CoDE’ Category
Code to update one column with a subquery that grabs the info from another column table. —
UPDATE tbl_grocery_inventory set col_curry_qty = col_curry_qty – 1 WHERE col_ID in (select col_id from tbl_fruit where col_id=2)
SQL Joins: 2 joins in one query —
This is a SQL SELECT Statement that is joining 3 tables. Please tell me what do you think to make it quicker and faster. Let me know what you think about this confusing subject of SQL joins! Thanks Scott @ http://scottalvarino.com