|
by: Yasaswi Pulavarti |
last post by:
I have a table called order_shipment with primary keys order_id,
order_item_seq_id etc. I also another table called order_item with
primary keys order_id, order_item_seq_id etc.
I want all the order_id's which look like '7000%' that are in
order_item but not in order_shipment. Please help me with creating the
sql. I tried UNION, LEFT OUTER...
|
by: news-east.earthlink.net |
last post by:
The scenario:
two tables
CustomerTable
---------------
CustomerID
OrderID
CustomerName
CustomerEmail
|
by: steve |
last post by:
Can you join two tables across different servers in mySQL, or am I
dreaming of Oracle?
--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/mySQL-Join-servers-ftopict225285.html
Visit Topic URL to contact author (reg....
|
by: Bibic0711 |
last post by:
I am having problem on following situation, any comments are welcome.
I have this table A which contents most of the data, that needs to be
query based on a name field in table B and was linked to table A by an
index. Then I need to minus another table C's data from table A with
the same index link from table B. How do I query from the...
|
by: dskillingstad |
last post by:
I would really appreciate someone's help on this, or at least point me
in the right direction....
I'm working on a permit database that contains 12 tables, and rather
than list all of the tables, I'll just list a few, as the links are the
same for all tables. These tables are:
tblPermitMain
tblApplicant
tblContractor
tblEngineer
|
|
by: Steve |
last post by:
One of our clients recently upgraded their Office version to 2003. When
they tried to run our program (written in Access 2000), they ended up
with the wrong data. My coworker and I have tested this problem and
found that it ONLY occurs on Windows XP machines running Office 2003.
The problem ends up being that ONE 1-to-1 join in ONE query...
|
by: Eitan M |
last post by:
Hello,
I want to do select like this :
select t1.col_2
from table_1 t1, table_2 t2
where t1.col_1 = t2.col_1 (+)
The above is correct syntax for Oracle.
What is the correct syntax for access.
(Not the syntax : left outer join table_1 on table_2 etc... , but something
|
by: Dr J R Stockton |
last post by:
Unicode U+00B1 is ± - a plus sign sitting on top of a minus sign,
possibly visible as "±"; "plus/minus", in ISO-7 coding.
As Alan will no doubt remember, algebraic work requiring that character
may well have need of its reciprocal, "minus/plus", a minus sign sitting
on top of a plus sign.
I've not found it in a middle-size list of...
|
by: Jane T |
last post by:
I appreciate how difficult it is to resolve a problem without all the
information but maybe someone has come across a similar problem.
I have an 'extract' table which has 1853 rows when I ask for all rows where
period_ = 3. The allocation table for info has 210 rows.
I have two scripts below. The first script where I specify a period on...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
|