by: david |
last post by:
Hi,
Gosh I've seen this b4 but I couldn't google it, ah just found it
eg search for records having same email address
select txtemail,count(txtemail) from `tbl_user` GROUP BY txtemail
having ...
|
by: Nicolae Fieraru |
last post by:
I have two tables, they contain:
Table1: ID1, Name1, Address1, Purchase1
Table2: ID2, Name2, Address2, Purchase2
I need a query which creates Table3 with content from Table1 and Table2.
The...
|
by: Mark Donners |
last post by:
Table1 and table 2 are in the same access database.
when i press a button(script) all records from table1 should be added to
table2.
How can i do this? Who can help
m donners
|
by: suffrinmick |
last post by:
Hi everyone!
I (Along with the help of some of you guys!) have managed to get a
query working which takes multiple values (types of organisation) from
a list box.
The query returns a list of...
|
by: ak1dnar |
last post by:
Hi all,
I am getting this error in my ASP.net App, when reading some records which contains Null values for some of the columns.
System.Data.SqlTypes.SqlNullValueException: Data is Null....
|
by: paulquinlan100 |
last post by:
Hi
I have the following query:
SELECT qryBlackbook.*
FROM qryBlackbook inner JOIN qryLatestMeetingDate ON
(qryBlackbook.Site_Ref = qryLatestMeetingDate.Site_Ref) AND...
|
by: JC2710 |
last post by:
Hi
I would like a Query that Updates a field to indicate that records have a duplicate entry( records with same values).
My table is .....
Code........Process..........Quantity
...
|
by: dlee360 |
last post by:
Hello!
So I've been trying to figure out how to do the following in T-SQL:
Orig Table:
Col1 Col2 Col3
Set A ...
|
by: Tomkat53 |
last post by:
Hello, I'm not sure if this has been asked here before (wouldn't know what to search for).
Here's my situation...
I have records in Table1 that I need to insert into Table2.
However, there is...
|
by: KPR1977 |
last post by:
In an Access Database for field2, the data values could consist of the following:
---field1-------------field2-------
Widget 1-----112398764567
Widget 2-----987611236789
Widget...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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...
|
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,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
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...
|
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...
|