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 |
|
stigmatized8
Starting Member
1 Post |
 Posted - 2003-02-24 : 10:24:09
|
| hi all im quite new to SQL, and i need to do a query which will (in my question given) "Display the Consultant ID and Name of all consultants on Salary Scale ‘S1’ who have not been assigned a company car or who have been assigned a company car of more than 1400cc."would anyone b able to advise on what command i would want to use for this?regards!! |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-02-24 : 11:01:02
|
| Well, its impossible to give exact t-sql statements without first seeing you ddl (data definition language ... create table statements).How about you post your ddl, some sample data and the expected result you are trying to achieve. Given clearer requirements I'm sure someone would be more than happy to help.Jay White{0} |
 |
|
|
|
|
|
SQL Basic Query's