How to make a Unique Multiple column (from multiple tables) Index

[peterv12]

I have a small database with 2 tables. One is mybooks, one is myauthor. What I want to do is create a unique multiple column index from columns in each table. What I'd like is essentially this:

From books table:  Title
From authors table: Name

New Unique Index: Title+Name

Where the New Unique Index is on the Books Table.

I've seen some examples, but none addresses creating the index from columns on different tables. I need to know if this can be done, and if so how? I have existing tables, so I'd like to be able to do it with ALTER TABLE commands if possible.

Any ideas would be greatly appreciated!
Peter V.

 

[Ziggurat]

Hi Peter V,

From the information that you have stated. I cannot give you an answer.

You mention 2 tables, mybooks and myauthor, but what are the fields in these 2 tables and how are the 2 table connected ?

Also do you want to create a new field in the mybooks table to hold you new unique index or do you already have an index field?

If you supply that information then I might be able to give you a solution.

#
###
#####
#######
Ziggurat

 

[r937]

you can not create an index which spans more than one table

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon