473,411 Members | 2,014 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > db2 database > questions > query returns empty records despite having equal values in all relational tables.

Join Bytes to post your question to a community of 473,411 software developers and data experts.

query returns empty records despite having equal values in all relational tables.

My team has made an online restaurant database.
It has following entities:
customer, admin, carrier, kitchen, fooditems and order (associative entity)

Some queries return correct records but some of them return empty records.
For example,
Customer, carrier, order
OR
admin, food items, carrier

Kindly help (we have a demo tomorrow)
Apr 15 '18 #1
2 2996
Luuk
1,047 Expert 1GB
ask your team to fix this a.s.a.p (before tomorrow)
Apr 15 '18 #2
Rabbit
12,516 Expert Mod 8TB
You've provided almost no information for us to go on... What is the SQL? What are the columns in the tables? What is some sample data?
Apr 15 '18 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

5
display problem when query is empty!?
by: Jerome | last post by:
Hi, I've got the following problem: I want my ASP page to display a certain number (based on a COUNT query), it works fine if the result is at least 1! If there are no records to be counted...
ASP / Active Server Pages
5
Null in subquery returns no records
by: Mike MacSween | last post by:
This as the row source for a combo: SELECT qryRole.RoleID, qryRole.Role FROM qryRole WHERE (((qryRole.RoleID) Not In (SELECT RoleID FROM qryRoleEvent INNER JOIN qryEvent ON qryRoleEvent.EventID...
Microsoft Access / VBA
5
close form if query returns no records
by: highway of diamonds | last post by:
I have a form based on a query. I would like to generate a msgbox and close the form should the query return no records. TIA R. PS I would even be happy to lose the form and just do the...
Microsoft Access / VBA
1
Problem with subform when paratmeter query returns NULL
by: Macbane | last post by:
Hi There, I have a main form that with a subform which is based on a parameter query. I have 2 controls on the main form & which are used as parameters in the query. It all works fine and...
Microsoft Access / VBA
3
Simple query returns 0 records in asp, but all records in vbscript
by: masg0013 | last post by:
I have a few vbscripts that I want to convert to asp pages so I can use html to format the data better. 1). Do asp pages have to be run from an IIS server or can I just create them locally...
ASP / Active Server Pages
2
WMI Query returns empty resultset
by: stigwulff | last post by:
I have made a ASP.NET ver. 2 webservice that runs on an Exchange 2003 server. In that webservice I want to get the size of the mailboxes on the Exchange server. I try to use WMI and the...
ASP.NET
10
Query most recent records for unique field values
by: rousseaud | last post by:
Hello- I'm having a little trouble. I want to create a query that will return the most recent records (by date) for all unique values in a certain field in the query. I'll be pulling data from 3...
Microsoft Access / VBA
6
arabic query returns empty result
by: unpresedented | last post by:
I have this query (that runs on Oracle 10g database): SELECT ge.*, ge.concept AS glossarypivot FROM s_glossary_entries ge WHERE (ge.glossaryid = '161' OR ge.sourceglossaryid = '161') AND...
Oracle Database
1
loop through records and disregard equal values
by: Drei Divina | last post by:
hi everyone, i need some assistance. i need to compare records from table A (database A) and records from table B (database B) and display list of this records. But i need to filter the list...
ASP / Active Server Pages
0
Migrating Website to Cloud - Emmanuel Katto
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
General
0
BarryA
Navigating the Data Structures and Algorithms (DSA)
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
Algorithms / Advanced Math
0
How to build RAID in BIOS?
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
Computer Hardware
0
marktang
What is ONU?
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
General
0
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++
0
The easy way to turn off automatic updates for Windows 10/11
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
Windows Server
0
agi2029
AI Job Threat for Devs
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
Career Advice
0
isladogs
Access Europe - Using VBA to create a class based on a table - Wed 1 May
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
Microsoft Access / VBA
0
Couldn’t get equations in html when convert word .docx file to html file in C#.
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
C# / C Sharp

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!