Ask Your Question

How can I create a query with 1:N relationship [closed]

asked 2015-11-18 15:55:31 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hello I have a database with this relationship diagram:

image description

I'm trying to create a query which is amge to provide the Father's phone number (ID pai is the key of the user which a father), and I don't know how.

This is what I've tried: image description

But I'm is not possible put on Criterion of "Numero telemovel" (phone's number) "ID Utilizador = ID Pai".

How can I do it?

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by Alex Kemp
close date 2016-03-14 00:15:31.690583


Alex Kemp gravatar imageAlex Kemp ( 2016-03-14 00:15:18 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2015-11-18 16:03:32 +0100

jay Arr gravatar image

Please attach a copy of your database to your question and then we can help constructing a query for you.

The attachments you have made to your question do not appear.

edit flag offensive delete link more


Thank you and I'm sorry for the incovinient. I cannot post the full database because it has personal data from its members. I hope these links could help.

Otherwise I could make a copy and clean all the data if it is necessary!

marcoE gravatar imagemarcoE ( 2015-11-26 14:14:04 +0100 )edit

Question Tools

1 follower


Asked: 2015-11-18 15:55:31 +0100

Seen: 41 times

Last updated: Nov 18 '15