Dumb question (joining tables)

2004-06-17 Thread
I have large fact table, in which there are much ids (that are in fact foreign keys but as long as I use MyISAM engine them are not technically). So when I try to join another table (that contains text descriptions for each id from one of fact columns, so it has two fields (id (PK) and name)) in

Re: Dumb question (joining tables)

2004-06-17 Thread gerald_clark
wrote: I have large fact table, in which there are much ids (that are in fact foreign keys but as long as I use MyISAM engine them are not technically). So when I try to join another table (that contains text descriptions for each id from one of fact columns, so it has two fields (id (PK) and