Click here to Skip to main content
15,907,395 members
Home / Discussions / C#
   

C#

 
AnswerRe: Status Of Printing Files Pin
Richard Deeming17-Apr-20 3:51
mveRichard Deeming17-Apr-20 3:51 
QuestionJoin 3 tables error : Incorrect syntax near '.'. Pin
Member 1266420916-Apr-20 3:59
Member 1266420916-Apr-20 3:59 
AnswerRe: Join 3 tables error : Incorrect syntax near '.'. Pin
Richard Deeming16-Apr-20 4:01
mveRichard Deeming16-Apr-20 4:01 
GeneralRe: Join 3 tables error : Incorrect syntax near '.'. Pin
Member 1266420916-Apr-20 4:10
Member 1266420916-Apr-20 4:10 
GeneralRe: Join 3 tables error : Incorrect syntax near '.'. Pin
Richard Deeming16-Apr-20 4:23
mveRichard Deeming16-Apr-20 4:23 
GeneralRe: Join 3 tables error : Incorrect syntax near '.'. Pin
Member 1266420916-Apr-20 5:07
Member 1266420916-Apr-20 5:07 
GeneralRe: Join 3 tables error : Incorrect syntax near '.'. Pin
Richard Deeming16-Apr-20 5:10
mveRichard Deeming16-Apr-20 5:10 
GeneralRe: Join 3 tables error : Incorrect syntax near '.'. Pin
OriginalGriff16-Apr-20 5:37
mveOriginalGriff16-Apr-20 5:37 
Start by cutting it down and trying it in SSMS:
SQL
SELECT p.pcode, p.pdesc, b.brand, c.category, p.price, p.qty 
FROM tblProduct p
INNER JOIN tblBrand b
       ON b.id = p.bid
WHERE p.pdesc LIKE '%'

And see if you get any rows.
If you don't, remove the JOIN and see what p.pid values you do get, then look at tblBrand to see if they exist. Remember that an INNER JOIN requires a matching entry in BOTH tables to return ANY rows.
If you do, add the second JOIN and see what you get.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!

Questionfilling a column with property value of object Pin
Aresto196414-Apr-20 20:39
Aresto196414-Apr-20 20:39 
AnswerRe: filling a column with property value of object Pin
joost.versteegen14-Apr-20 20:52
joost.versteegen14-Apr-20 20:52 
GeneralRe: filling a column with property value of object Pin
Aresto196415-Apr-20 3:33
Aresto196415-Apr-20 3:33 
AnswerRe: filling a column with property value of object Pin
OriginalGriff14-Apr-20 21:34
mveOriginalGriff14-Apr-20 21:34 
QuestionTarga files displayed in openFileDialog Pin
MikeBr13-Apr-20 22:26
MikeBr13-Apr-20 22:26 
AnswerRe: Targa files displayed in openFileDialog Pin
OriginalGriff13-Apr-20 23:19
mveOriginalGriff13-Apr-20 23:19 
AnswerRe: Targa files displayed in openFileDialog Pin
Richard Deeming14-Apr-20 0:15
mveRichard Deeming14-Apr-20 0:15 
AnswerRe: Targa files displayed in openFileDialog Pin
Dave Kreskowiak14-Apr-20 4:37
mveDave Kreskowiak14-Apr-20 4:37 
QuestionProgramming Tcp with C# Pin
Member 1478193513-Apr-20 21:13
Member 1478193513-Apr-20 21:13 
AnswerRe: Programming Tcp with C# Pin
OriginalGriff13-Apr-20 21:25
mveOriginalGriff13-Apr-20 21:25 
GeneralRe: Programming Tcp with C# Pin
Member 1478193519-Apr-20 3:24
Member 1478193519-Apr-20 3:24 
QuestionSaving usercontrol design-time properties Pin
Crazy Joe Devola13-Apr-20 14:49
Crazy Joe Devola13-Apr-20 14:49 
AnswerRe: Saving usercontrol design-time properties Pin
OriginalGriff13-Apr-20 20:00
mveOriginalGriff13-Apr-20 20:00 
AnswerRe: Saving usercontrol design-time properties Pin
Richard Deeming14-Apr-20 0:13
mveRichard Deeming14-Apr-20 0:13 
GeneralRe: Saving usercontrol design-time properties Pin
Crazy Joe Devola14-Apr-20 13:45
Crazy Joe Devola14-Apr-20 13:45 
QuestionPrint Multiple Page in c# Pin
Mohamed Fahad13-Apr-20 9:08
Mohamed Fahad13-Apr-20 9:08 
AnswerRe: Print Multiple Page in c# Pin
Pete O'Hanlon13-Apr-20 9:30
mvePete O'Hanlon13-Apr-20 9:30 

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.