|
Sorry I don't understand what your problem is, you can change the join in query builder if they don't suit your query.
Seems you have almost no knowledge of databases and are relying heavily on the built in tools to do your work for you. I suggest you get a basic book on database design and start learning. Using a forum for your basic learning is NOT a good idea, get a book or do a course!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Let me try to rephrase this for you using sentence structure:
"I am working with a windows app with sql database and vb. I have created 4 tables:
singlecustomer
jointcustomer
address
plotdetails
I have created relationships with all 4 tables:
singlecustomer related to plotdetails and address
jointcustomer related to plotdetails and address
I have created the database diagram and it shows all of the relationships.
When I drag and drop a sql adapter to configure it, the database relationships don't look right in the query builder.
In query builder when I add tables the first time, it shows a relationship. When I cancel it and add tables a second time in a different order, it shows a different relationship"
Now, that's what your question looks like with proper sentence structure...however, it still doesn't make a lot of sense.
|
|
|
|
|
|
This is an advert for his database. Guess which one?
|
|
|
|
|
My database. Thanks a lot for this compliment.
That is one very impresive benchmark which is OpenSource and is quite suited to get an overview about the performance of the different DBMS. Wich DBMS will you using is only your choose.
Between I'm PHP programmer and until this moment i'm using MySQL.
Best Regards, Good Luck.
|
|
|
|
|
Well at least he chose an appropriate userid. 
It's time for a new signature.
|
|
|
|
|
I think he needs to invert the 'p' to a 'b'. 
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
|
|
|
|
|
Hi,
I'm trying to create an album gallery, which works this way:
First, i have the album photos with description on each album under the photo, with a pager. ( that was done)
Second, when you click on a certain album, you see all photos related to this album only.
I am using ACCESS DB. i just cant figure it out how to connect those data correctly, and how clicking an album will take me to the photos related only to it.
I would appreciate any help or samples for such a thing.
Thanks,
Basil
|
|
|
|
|
That would depend on your schema.
|
|
|
|
|
Hi,
I have a Address field.I want to make a query that returns all records that their addresses contain all words of a address in any order.
Suppose 'John street , No 2' is the address, I want to return all addresses that contains 'John' , 'street', 'No' and '2' in any order.
How can I make this query?
Original string : My name is Mehrdad
Best wishes
|
|
|
|
|
Use and with like
SELECT *
FROM Somehwere
WHERE address1 LIKE '%John%'
AND address1 LIKE '%Street%'
AND address1 LIKE '%No%'
However this is not going to help where you have St instead of Street ,Rd instead of Road and many many more issues that arise from cleaning address data.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
You can use SOUNDEX[^]
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
Hi Guys,
We are newly insurance based company that we are holding most insurance like
*Auto Insurance
*Health Insurance
*Life Insurance
And still we are developing on lot more insurance is there any other insurance quotes that are to be added, Please give us your suggestion about it………………………..
|
|
|
|
|
|
posting in non appropriate forums.
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
|
|
|
|
|
Insurance against insurers denying claims on spurious grounds based on arcane interpretations of small print.
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
The only valid measurement of code quality: WTFs/minute.
|
|
|
|
|
With ado and vb6 classic.
I have sql table with approx 4.500.000 records.
How to copy all sql records into the access table via vb6 code, and with fasted method?
|
|
|
|
|
Could you let me know your target version of MS Access database and do you have any plan to do this by SQL Server DTS services via VB?
Thanks
Md. Marufuzzaman
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
|
|
|
|
|
-access 2003.
-Vb6 classic
I cannot have permission Sql Server, but have only a redaing on the sql table.
If for you is a god way to use DTS in vb code this solution is welcome!
Yes if is possible make all wiyh vb6 classic.
Tks.
|
|
|
|
|
hi,
how can we write CURSOR in Pl/SQL.Plz send me the syntax of it.
Thanks
Richa
|
|
|
|
|
Go to Google, Bing or the search engine of your choice.
Type "pl/sql cursor".
Press Enter.
|
|
|
|
|
richa021 wrote: Plz send me the syntax of it.
You're looking for the Manual[^]? 
I are Troll 
|
|
|
|
|
Oh My God.
Please please please get a dba to do this for you.
Dave: But I don't wanna be a barbarian!
Fang: You did when you were ten!
Dave: Yes, but I thought it meant a librarian that also cuts hair.
|
|
|
|
|
I am using MS Sql 2005. In my database I have a table "Products" which has following structure and content
ProductName CategoryId AddedDate
Product1 1 04/12/2010
Product2 1 04/12/2010
Product3 2 05/12/2010
Product4 1 06/12/2010
I want to fetch top 2 records order by AddedDate. To do that I can use sql
Select top 2 * From Products Order By AddedDate
This will populate first two records. Both are in CategoryId "1". I want to Select records from distinct categories.
I requirment is to select records order by AddedDate with distinct CategoryId. I can do it with temporary tables. But is there any simple query to do that?
Thanks and regards,
Poppy
modified on Thursday, May 27, 2010 9:33 AM
|
|
|
|
|
SELECT DISTINCT TOP 2 <br />
<br />
p.CategoryId,<br />
(SELECT TOP 1 p2.AddDate<br />
FROM products p2 WHERE p2.CategoryId = p. CategoryId) AS adddate<br />
<br />
FROM<br />
products p<br />
ORDER BY p.CategoryId<br />
Hope this will help you.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
modified on Thursday, May 27, 2010 10:45 AM
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
