Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
suman123
Starting Member
5 Posts |
 Posted - 2003-09-09 : 12:40:42
|
| Hi Guys,I know that this is a SQL Server forum, but pls bear with me and help me out. I am trying to do a left join in Oracle using TOAD to run my query and I cant seem to find the right syntax for the SQL query. Here is what my query looks like so far :select e.emp_val1 as location, e.emp_val3 as dept, e.emp_val2 as clock, e.emp_lastname || ', ' || e.emp_firstname as name, ws1.wrks_udf1 as rate1, ws2.wrks_udf1 as rate2, ws3.wrks_udf1 as rate3, ws4.wrks_udf1 as rate4, ws5.wrks_udf1 as rate5, ws6.wrks_udf1 as rate6 from employee e, work_summary ws1, work_summary ws2, work_summary ws3, work_summary ws4, work_summary ws5, work_summary ws6 where e.emp_val1 = 01060048 and ws1.emp_id = e.emp_id and ws2.emp_id = e.emp_id and ws3.emp_id = e.emp_id and ws4.emp_id = e.emp_id and ws5.emp_id = e.emp_id and ws6.emp_id = e.emp_id ..... .....Basically, I need to do a left join on employee and work_summary1 thru 6. Any ideas how this is done in Oracle SQL ?Thanks so much !S |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-09 : 12:43:27
|
| Since this is a SQL Server forum, your question most likely is not going to be answered here. I would suggest finding an Oracle site and post your question there.Tara |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2003-09-09 : 13:44:21
|
| A reference book for PL/SQL is probably available, and highly recommended. There were a number of good ones for T-SQL, so I'm sure you could find one that would work for you. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-09 : 14:20:35
|
| Or you can check out this site...all the manuals you'll probably need..http://www-dbs.inf.ethz.ch/~oracle/It's a German site...but the manuals are in English...Brett8-)SELECT @@POST=NewId()That's correct! It's an AlphaNumeric! |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-09 : 14:23:26
|
| Those are 9i btw...I only worked with 8i..Seems 9i has added the ANSI standard joins now..But NOT in 8i...Brett8-)SELECT @@POST=NewId()That's correct! It's an AlphaNumeric! |
|
|
|
|
|
|
|
|
Oracle SQL question