cudaboy_71
asked on
simple outer join in FMP6 Mac
complete noob to FMP. I launched it for the first time about an hour ago. Hopefully this is just an application user interface problem i'm having. but, i can't seem to figure out how to do the simplest task in FM. But, i'm stuck with the application. There's no copy of MSAccess here at this location for me to use.
TASK: take two tables with mailing list data, one of which has already been mailed, and remove all the duplicate entries from the other list so that noone is mailed twice.
in access i'd just do an outer join like:
[code]
SELCT * FROM UNMailedlist.company LEFT OUTER JOIN Mailedlist.company
[/code]
then, do some manual tweaking from there.
but, aside from setting up the UnMailelist.company=Mailed
please don't assume anything (like i understand the basics of how FM works). i'm staring at the screen with a blank look. i'd have better luck with a blindfold at this point.
any help for a lost soul?
TASK: take two tables with mailing list data, one of which has already been mailed, and remove all the duplicate entries from the other list so that noone is mailed twice.
in access i'd just do an outer join like:
[code]
SELCT * FROM UNMailedlist.company LEFT OUTER JOIN Mailedlist.company
[/code]
then, do some manual tweaking from there.
but, aside from setting up the UnMailelist.company=Mailed
please don't assume anything (like i understand the basics of how FM works). i'm staring at the screen with a blank look. i'd have better luck with a blindfold at this point.
any help for a lost soul?
ASKER
sorry. i guess i didn't it clear that i'm having trouble with the FM interface.
I understand that i need a Join. But, i have no idea where to put it. the interface is foreign and there is no help for Joins in the builtin help.
in other words, the answer to this question will not be in the form of a single sentence. i need help with where to put the join, and how to reveal the query in FM once the join is made.
like i said, i'm just staring at the screen with no idea what menu or button to click. if i had a manual i'd read it. if there was a helpfile on joins i'd read it. right now i'm in search of a rosetta stone for FM->Access.
I understand that i need a Join. But, i have no idea where to put it. the interface is foreign and there is no help for Joins in the builtin help.
in other words, the answer to this question will not be in the form of a single sentence. i need help with where to put the join, and how to reveal the query in FM once the join is made.
like i said, i'm just staring at the screen with no idea what menu or button to click. if i had a manual i'd read it. if there was a helpfile on joins i'd read it. right now i'm in search of a rosetta stone for FM->Access.
in fm6, in order to use a sql select command, you need to setup a table with the fields to store the fields resulting from the select command via an import action.
so define data base and create the fields to accept data from the sql databse.
now, use file/import, ODBC source (assuming this already exist on yr machine) then use the wizard to make up the sql query or type it directly in the window.
When you execute the query, you'll get a matching window to let fm which field goes where.
so define data base and create the fields to accept data from the sql databse.
now, use file/import, ODBC source (assuming this already exist on yr machine) then use the wizard to make up the sql query or type it directly in the window.
When you execute the query, you'll get a matching window to let fm which field goes where.
ASKER
hrm...maybe FM6 is not so robust as i thought it was. All i want to do is take two tables of similar data (addresses) and do some comparison operations on them. they do not necessarliy have to be in SQL (which looks like it will be a headache). is it not possible to have a couple of tables of data and do a lookup based upon some typical DB type criteria like "show records with unique field value 'x'" or "show records with matching field value 'x'"?
yes, but it is simply different from sql, you do this using simple find commands. and you write a script when the manual usage becomes too complex.
first you must create a relationship in between them (kind of permanent join), then place the fields you need in a layout, then use them to search data. f you start from scratch, it may be worth using another tool you are familiar with like excel?
first you must create a relationship in between them (kind of permanent join), then place the fields you need in a layout, then use them to search data. f you start from scratch, it may be worth using another tool you are familiar with like excel?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
excellent instructions. exactly what i was looking for. thanks to the other commentors for some insight into how FM works. but, JoJohn's step by step instructions gave me the results i have been after in less than 2 minutes.
many thanks.
many thanks.
You are certainly welcome.
for a JOIN, you need a JOIN condition...