Click here to Skip to main content
15,671,405 members
Home / Discussions / C#
   

C#

 
GeneralRe: New SQL question also urgent Pin
Vikram A Punathambekar27-Aug-07 1:23
Vikram A Punathambekar27-Aug-07 1:23 
GeneralRe: New SQL question also urgent Pin
Colin Angus Mackay27-Aug-07 0:47
Colin Angus Mackay27-Aug-07 0:47 
GeneralRe: New SQL question also urgent Pin
Paul Conrad16-Sep-07 17:32
professionalPaul Conrad16-Sep-07 17:32 
GeneralRe: New SQL question also urgent Pin
falles0116-Sep-07 18:07
falles0116-Sep-07 18:07 
GeneralRe: New SQL question also urgent Pin
Colin Angus Mackay16-Sep-07 21:15
Colin Angus Mackay16-Sep-07 21:15 
GeneralRe: New SQL question also urgent Pin
Dave Kreskowiak27-Aug-07 3:55
mveDave Kreskowiak27-Aug-07 3:55 
GeneralRe: New SQL question also urgent Pin
Paul Conrad16-Sep-07 17:31
professionalPaul Conrad16-Sep-07 17:31 
AnswerRe: New SQL question also urgent Pin
Christian Graus27-Aug-07 0:21
protectorChristian Graus27-Aug-07 0:21 
Gosh - didn't they even give you a book on SQL ? Have you not had time to read about SQL using google or something ?

I suggested a few days ago that any SQL you write, you should test directly against your database to get the best possible error info. In this case, your SQL is plain wrong. To combine two conditions, use 'and', and to combine two tables, use joins. Something like ( this won't work )

select e.firstname from employees e inner join roles r on e.roleId = r.RoleId where e.FirstName = 'fred' and r.roleId = 4

Not sure if you have a role table, what you need it for, if you're not looking anything up in it. I mean, if you cannot join the two tables, then you can't use them together, and odds are that it's a lookup table for role names, so you can then expect the role id to be in both tables, and you can look it up in the employee table.


Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

GeneralRe: New SQL question also urgent Pin
falles0127-Aug-07 12:54
falles0127-Aug-07 12:54 
GeneralRe: New SQL question Pin
falles0127-Aug-07 13:09
falles0127-Aug-07 13:09 
AnswerRe: New SQL question also urgent Pin
Christian Graus27-Aug-07 0:23
protectorChristian Graus27-Aug-07 0:23 
QuestionChange Scroll Bar location Pin
greekius26-Aug-07 21:56
greekius26-Aug-07 21:56 
AnswerSOLVED ! Pin
greekius26-Aug-07 22:14
greekius26-Aug-07 22:14 
QuestionWhat is C# version of this Code...? Pin
ASysSolvers26-Aug-07 20:53
ASysSolvers26-Aug-07 20:53 
AnswerRe: What is C# version of this Code...? Pin
Marek Grzenkowicz26-Aug-07 21:32
Marek Grzenkowicz26-Aug-07 21:32 
GeneralRe: What is C# version of this Code...? Pin
ASysSolvers26-Aug-07 22:18
ASysSolvers26-Aug-07 22:18 
GeneralRe: What is C# version of this Code...? Pin
Vasudevan Deepak Kumar26-Aug-07 23:49
Vasudevan Deepak Kumar26-Aug-07 23:49 
GeneralRe: What is C# version of this Code...? Pin
Marek Grzenkowicz27-Aug-07 0:06
Marek Grzenkowicz27-Aug-07 0:06 
AnswerRe: What is C# version of this Code...? Pin
Guffa26-Aug-07 23:49
Guffa26-Aug-07 23:49 
GeneralRe: What is C# version of this Code...? Pin
ASysSolvers27-Aug-07 1:18
ASysSolvers27-Aug-07 1:18 
QuestionPlease Help- only have half a day Pin
falles0126-Aug-07 20:49
falles0126-Aug-07 20:49 
AnswerRe: Please Help- only have half a day Pin
VanithaVasu26-Aug-07 21:07
VanithaVasu26-Aug-07 21:07 
GeneralRe: Please Help- only have half a day Pin
falles0126-Aug-07 21:19
falles0126-Aug-07 21:19 
AnswerRe: Please Help- only have half a day Pin
avinob26-Aug-07 21:33
avinob26-Aug-07 21:33 
GeneralRe: Please Help- only have half a day Pin
falles0126-Aug-07 22:07
falles0126-Aug-07 22:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.