Click here to Skip to main content
       

Database

 
QuestionAttendance and leave of employees PinmemberAmr Muhammed25-Sep-12 13:06 
AnswerRe: Attendance and leave of employees [modified] Pinmemberihoecken25-Sep-12 20:50 
GeneralRe: Attendance and leave of employees [modified] PinmemberAndrei Straut25-Sep-12 21:03 
GeneralRe: Attendance and leave of employees Pinmemberihoecken25-Sep-12 21:19 
GeneralRe: Attendance and leave of employees PinmemberAndrei Straut25-Sep-12 21:20 
QuestionConvert datetime to certain format Pinmembervanikanc25-Sep-12 9:09 
AnswerRe: Convert datetime to certain format Pinmemberihoecken25-Sep-12 20:58 
QuestionSql server topics and materials PinmemberAzizullahazizi24-Sep-12 18:32 
AnswerRe: Sql server topics and materials PinmemberAndrei Straut24-Sep-12 20:12 
AnswerRe: Sql server topics and materials PinmvpSandeep Mewara24-Sep-12 20:23 
QuestionSQL Search within a table Pinmemberveon cheng24-Sep-12 9:31 
AnswerRe: SQL Search within a table Pinmemberdjj5525-Sep-12 1:08 
GeneralRe: SQL Search within a table Pinmemberveon cheng25-Sep-12 3:37 
AnswerRe: SQL Search within a table Pinmemberihoecken25-Sep-12 4:13 
veon cheng wrote:
I wanted to display the main category of the Juice which is beverage. No matter how hard i tried, i can't display the Main category in access.

 
SELECT a.CategoryName
FROM Category a INNER JOIN Category b On a.CatId = b.SubId
WHERE b.SubCategory = 'Juice';
------------------------------
Author of Primary ROleplaying SysTem
 
How do I take my coffee? Black as midnight on a moonless night.
War doesn't determine who's right. War determines who's left.

QuestionCONNECTING MSSQL DB FILE FROM PEN DRIVE Pinmemberr_mohd22-Sep-12 22:38 
AnswerRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE PinmemberEddy Vluggen23-Sep-12 2:38 
AnswerRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pinmemberjschell23-Sep-12 8:10 
GeneralRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pinmemberr_mohd24-Sep-12 2:28 
GeneralRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pinmemberjschell24-Sep-12 12:37 
QuestionDb over internet Pinmemberleone22-Sep-12 8:56 
AnswerRe: Db over internet PinmemberEddy Vluggen23-Sep-12 0:42 
AnswerRe: Db over internet Pinmemberjschell23-Sep-12 8:16 
GeneralRe: Db over internet Pinmemberleone24-Sep-12 0:45 
GeneralRe: Db over internet PinmemberJörgen Andersson24-Sep-12 2:05 
AnswerRe: Db over internet PinmemberChris Quinn27-Sep-12 2:36 
Questionconnection of mssql 2008 to cloud in windows form application PinmemberKUNWAR99921-Sep-12 3:28 
AnswerRe: connection of mssql 2008 to cloud in windows form application PinmemberDavid Mujica21-Sep-12 3:50 
AnswerRe: connection of mssql 2008 to cloud in windows form application PinmemberEddy Vluggen21-Sep-12 4:44 
QuestionSQL XP_StartSMTP to send email PinmemberMWRivera20-Sep-12 5:45 
AnswerRe: SQL XP_StartSMTP to send email PinmemberChris Meech21-Sep-12 2:45 
AnswerRe: SQL XP_StartSMTP to send email PinmemberEddy Vluggen21-Sep-12 4:47 
QuestionContinuous absent query PinmemberRA|-|UL PATEL20-Sep-12 3:16 
AnswerRe: Continuous absent query Pinmemberdjj5520-Sep-12 8:04 
AnswerRe: Continuous absent query PinmemberHiteshDR5-Nov-12 23:24 
Questionhow to update combobox values in msaccess tables in ACCESS2007 Pinmembersowmya4919-Sep-12 20:40 
QuestionSpecifying Seed Values on model building Pinmembersolomon20118-Sep-12 5:34 
AnswerRe: Specifying Seed Values on model building PinmemberSimon_Whale18-Sep-12 5:47 
GeneralRe: Specifying Seed Values on model building Pinmembermark merrens18-Sep-12 8:19 
AnswerRe: Specifying Seed Values on model building Pinmembermark merrens18-Sep-12 8:22 
AnswerRe: Specifying Seed Values on model building PinmemberEddy Vluggen21-Sep-12 4:52 
Questionmultiple data instances one machine PinmemberJohn Robert Wilk17-Sep-12 8:15 
AnswerRe: multiple data instances one machine PinmemberJörgen Andersson17-Sep-12 8:55 
AnswerRe: multiple data instances one machine PinmemberWes Aday17-Sep-12 9:01 
GeneralRe: multiple data instances one machine PinmemberJohn Robert Wilk17-Sep-12 9:08 
GeneralRe: multiple data instances one machine PinmemberWes Aday17-Sep-12 9:14 
GeneralRe: multiple data instances one machine PinmemberJohn Robert Wilk17-Sep-12 9:17 
GeneralRe: multiple data instances one machine PinmemberWes Aday17-Sep-12 9:23 
AnswerRe: multiple data instances one machine Pinmemberjschell17-Sep-12 9:16 
GeneralRe: multiple data instances one machine PinmemberJohn Robert Wilk17-Sep-12 9:21 
GeneralRe: multiple data instances one machine Pinmemberjschell18-Sep-12 8:00 

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

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


Advertise | Privacy | Mobile
Web01 | 2.8.140821.2 | Last Updated 21 Aug 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid