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
Browsing Posts tagged SQL
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)
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
Sybase Ase 12.5 Video To find Out Address and Ports
This is for A Unix Solaris Box, I never had access to its Sybase before and needed to find out how to remotely connect with it to use different tools to write reports and administer the system. this is much like in the Microsoft SQL DB world where you have SQL Query Analyser and Enterprise Manager For the Windows Side of things.
Will have up soon, please let me know if this of any interest?
Scott
