Click here to Skip to main content
16,019,768 members
Home / Discussions / Database
   

Database

 
AnswerRe: SQL server query Pin
Richard Andrew x646-Oct-15 7:10
professionalRichard Andrew x646-Oct-15 7:10 
AnswerRe: SQL server query Pin
RNA Team10-Oct-15 8:33
RNA Team10-Oct-15 8:33 
QuestionHOW TO COPY DBF Files in VB.NET Pin
sunil8800891-Oct-15 22:17
sunil8800891-Oct-15 22:17 
AnswerRe: HOW TO COPY DBF Files in VB.NET Pin
phil.o1-Oct-15 23:55
professionalphil.o1-Oct-15 23:55 
AnswerRe: HOW TO COPY DBF Files in VB.NET Pin
Patrice T2-Oct-15 0:56
mvePatrice T2-Oct-15 0:56 
GeneralRe: HOW TO COPY DBF Files in VB.NET Pin
sunil8800893-Oct-15 21:50
sunil8800893-Oct-15 21:50 
Questionreturn the results from Query union the external proc in DB2 Pin
sudevsu30-Sep-15 8:49
sudevsu30-Sep-15 8:49 
QuestionDatabase relationship for tables Pin
maugonza30-Sep-15 8:43
maugonza30-Sep-15 8:43 
Now the GlobalEntityID is a seperate table that holds the company demographics. So each company can have multiple license attached to company. They can also have multiple invoice attached to company.
My question is the end user wants a report that shows company info, license number and invoice attached to each license number. But It does not work cause the invoice is attache to the company not each individual license number.

Is it possible to create get data for each license number when invoices are related to the company table only and not the license number. The report needs to show license numbers with or with out an invoice? When I run the report in SQL Query I can see same invoices for all license numbers, but in the user application I can pull a license number up and see that there is no invoice attached to it. How is this possible when there is no relationship between one license to one invoice?

License Table Fields Invoice Table Fields
PK LICENSEID PK INVOICEID
LICENSENUMBER CASTATUSID
ISSUEDBY INVOICENUMBER
LICENSETYPEID GLOBALENTITYID
LICENSESTATUSID INVOICETOTAL
ISSUEDATE INVOICEDATE
EXPIRATIONDATE INVOICEDESCRIPTION
LASTCHANGEDON ROWVERSION
LASTCHANGEDBY LASTCHANGEDON
ROWVERSION LASTCHANGEDBY
GLOBALENTITYID INVOICEDUEDATE
LICNESEPARENTID
DISTRICTID
LICENSECLASSIFICATIONID
APPLIEDDATE
LASTRENEWALDATE
LICENSEYEAR
LICENSEGROUPID
DESCRIPTION
GLOBALENTITYACCOUNTID
CALENDARDUEDATE
ISAPPLIEDONLINE
IMPORTEDCUSTOMER
AnswerRe: Database relationship for tables Pin
Jörgen Andersson1-Oct-15 2:12
professionalJörgen Andersson1-Oct-15 2:12 
SuggestionRe: Database relationship for tables Pin
Nathan Minier1-Oct-15 7:15
professionalNathan Minier1-Oct-15 7:15 
QuestionMSaccess query to access random value from database Pin
Member 1202314130-Sep-15 4:50
Member 1202314130-Sep-15 4:50 
QuestionMusic Database Pin
morrism3530-Sep-15 2:30
morrism3530-Sep-15 2:30 
AnswerRe: Music Database Pin
Richard MacCutchan30-Sep-15 3:05
mveRichard MacCutchan30-Sep-15 3:05 
QuestionQuery is not producing the correct results(SOLVED) Pin
samflex28-Sep-15 5:45
samflex28-Sep-15 5:45 
AnswerRe: Query is not producing the correct results Pin
Richard Deeming28-Sep-15 6:22
mveRichard Deeming28-Sep-15 6:22 
GeneralRe: Query is not producing the correct results Pin
samflex28-Sep-15 7:32
samflex28-Sep-15 7:32 
QuestionMove GROUP_CONCAT's comma values to columns Pin
Jassim Rahma22-Sep-15 22:03
Jassim Rahma22-Sep-15 22:03 
Questionpostgresql database issues Pin
Member 1191972221-Sep-15 22:09
Member 1191972221-Sep-15 22:09 
AnswerRe: postgresql database issues Pin
Richard MacCutchan21-Sep-15 22:50
mveRichard MacCutchan21-Sep-15 22:50 
GeneralRe: postgresql database issues Pin
Member 1191972221-Sep-15 23:23
Member 1191972221-Sep-15 23:23 
GeneralRe: postgresql database issues Pin
Richard MacCutchan21-Sep-15 23:27
mveRichard MacCutchan21-Sep-15 23:27 
GeneralRe: postgresql database issues Pin
Member 1191972221-Sep-15 23:31
Member 1191972221-Sep-15 23:31 
GeneralRe: postgresql database issues Pin
Member 1191972221-Sep-15 23:34
Member 1191972221-Sep-15 23:34 
GeneralRe: postgresql database issues Pin
Richard MacCutchan21-Sep-15 23:52
mveRichard MacCutchan21-Sep-15 23:52 
GeneralRe: postgresql database issues Pin
Member 1191972221-Sep-15 23:56
Member 1191972221-Sep-15 23:56 

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.