Click here to Skip to main content
16,005,038 members
Home / Discussions / C#
   

C#

 
GeneralRe: Letting a user choose a file for renaming Pin
scotlandc14-Oct-04 5:43
scotlandc14-Oct-04 5:43 
GeneralNeed help to: Read binary file into a struct Pin
Gywox13-Oct-04 5:07
Gywox13-Oct-04 5:07 
GeneralRe: Need help to: Read binary file into a struct Pin
Corinna John13-Oct-04 6:14
Corinna John13-Oct-04 6:14 
GeneralGet property Pin
bbp00613-Oct-04 4:48
bbp00613-Oct-04 4:48 
GeneralRe: Get property Pin
Colin Angus Mackay13-Oct-04 5:22
Colin Angus Mackay13-Oct-04 5:22 
GeneralRe: Get property Pin
Corinna John13-Oct-04 5:56
Corinna John13-Oct-04 5:56 
GeneralJOIN Pin
pat27088113-Oct-04 4:41
pat27088113-Oct-04 4:41 
GeneralRe: JOIN Pin
Colin Angus Mackay13-Oct-04 5:27
Colin Angus Mackay13-Oct-04 5:27 
pat270881 wrote:
SELECT p.JobId, p.Priority, c.CompanyName, c.ContactLName FROM JobDescription p INNER JOIN Client c ON p.EngineerUserId = ? ORDER BY p.Priority

Do you mean the ? as a parameter placeholder of that you don't know what you should put there.

If it is the latter then:
INNER JOIN Client p.EngineerUserId = c.EquivalentColumnNameInClientTable

If you need to add a condition you should add a WHERE clause before the ORDER BY

so you might get something like this (I've assumed that the client table has a column called EngineerUserId, if it doesn't you need to replace it with the column that does contain that value)
SELECT p.JobId, p.Priority, c.CompanyName, c.ContactLName 
FROM JobDescription p 
INNER JOIN Client c ON p.EngineerUserId = c.EngineerUserId
WHERE p.EngineerUserId = ?
ORDER BY p.Priority


Oh, and by the way, this should really have gone in the SQL Forum[^]


Do you want to know more?


Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.
GeneralRe: JOIN Pin
pat27088113-Oct-04 5:49
pat27088113-Oct-04 5:49 
GeneralTab Pane Pin
mathon13-Oct-04 4:16
mathon13-Oct-04 4:16 
GeneralRe: Tab Pane Pin
mathon13-Oct-04 4:17
mathon13-Oct-04 4:17 
GeneralRe: Tab Pane Pin
pat27088113-Oct-04 7:19
pat27088113-Oct-04 7:19 
GeneralRe: Tab Pane Pin
J4amieC13-Oct-04 7:50
J4amieC13-Oct-04 7:50 
GeneralRe: Tab Pane Pin
pat27088113-Oct-04 8:21
pat27088113-Oct-04 8:21 
GeneralRe: Tab Pane Pin
Dave Kreskowiak13-Oct-04 9:29
mveDave Kreskowiak13-Oct-04 9:29 
GeneralSomeone please bail me out.... Pin
Vodstok13-Oct-04 3:58
Vodstok13-Oct-04 3:58 
GeneralRe: Someone please bail me out.... Pin
benjymous13-Oct-04 5:10
benjymous13-Oct-04 5:10 
GeneralRe: Someone please bail me out.... Pin
Vodstok13-Oct-04 6:30
Vodstok13-Oct-04 6:30 
GeneralRe: Someone please bail me out.... Pin
J4amieC13-Oct-04 7:47
J4amieC13-Oct-04 7:47 
GeneralRe: Someone please bail me out.... Pin
Vodstok13-Oct-04 8:25
Vodstok13-Oct-04 8:25 
GeneralRe: Someone please bail me out.... Pin
benjymous13-Oct-04 20:52
benjymous13-Oct-04 20:52 
Generalproblem with measureString in textBox Pin
shimritb13-Oct-04 3:40
shimritb13-Oct-04 3:40 
GeneralForm Causesvalidation property Pin
Zapss13-Oct-04 3:10
Zapss13-Oct-04 3:10 
GeneralRe: Form Causesvalidation property Pin
J4amieC13-Oct-04 3:18
J4amieC13-Oct-04 3:18 
General.NET Remoting Pin
Wender Oliveira13-Oct-04 2:48
Wender Oliveira13-Oct-04 2:48 

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.