Phillips
|
| Posted: 03/25/2002, 2:21 PM |
|
Hi,
I'm having two tables, table1, table2. Table2 is a multiple subset of
Table1. What I am trying to do is to create a report of Table1 and Table2
in one search queries or display Table1 and Table2 result in onepage. I
have try the join command but got an error messege of "type mismatch".
Could someone be kind enuf and give me a step by step to solve this problem?
Thank you in advance.
m.
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 03/26/2002, 2:18 AM |
|
How did you do that JOIN , via JOIN tab in Field Properties or
by putting custom sql statement in SQL tab ?
--
Alex
CodeCharge Developer
"Phillips" <fdiskboy@msn.com> wrote in message
news:a7o7ss$s80$1@news.codecharge.com...
> Hi,
>
> I'm having two tables, table1, table2. Table2 is a multiple subset of
> Table1. What I am trying to do is to create a report of Table1 and Table2
> in one search queries or display Table1 and Table2 result in onepage. I
> have try the join command but got an error messege of "type mismatch".
> Could someone be kind enuf and give me a step by step to solve this
problem?
>
> Thank you in advance.
> m.
>
>
|
|
|
|
Phillips
|
| Posted: 03/26/2002, 6:30 AM |
|
Thank you, Alexey for your reply.
i used the Join in the Field Properties.
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:a7phu5$aaq$2@news.codecharge.com...
> How did you do that JOIN , via JOIN tab in Field Properties or
> by putting custom sql statement in SQL tab ?
>
> --
> Alex
> CodeCharge Developer
>
>
> "Phillips" <fdiskboy@msn.com> wrote in message
>news:a7o7ss$s80$1@news.codecharge.com...
> > Hi,
> >
> > I'm having two tables, table1, table2. Table2 is a multiple subset of
> > Table1. What I am trying to do is to create a report of Table1 and
Table2
> > in one search queries or display Table1 and Table2 result in onepage. I
> > have try the join command but got an error messege of "type mismatch".
> > Could someone be kind enuf and give me a step by step to solve this
> problem?
> >
> > Thank you in advance.
> > m.
> >
> >
>
>
>
|
|
|
|
RonB
|
| Posted: 03/27/2002, 9:04 AM |
|
On Tue, 26 Mar 2002 15:30:37 +0100, Phillips wrote:
> Thank you, Alexey for your reply.
> i used the Join in the Field Properties.
Looks like you are joining fields of different types ie a text field to a
number field. if you have a table like tablea(id, name, category(number)) and a table
like tableb(category_id(number),category_desc) you would have to join category to
category_id
RonB
|
|
|
|
|
