<div>
If you mean references as in foreign key, no. &nbsp;You need to reference either a primary or unique index/constraint when creating a foreign key. &nbsp;But as far as joining the tables in a select statement, yes. &nbsp;You can join two tables together that do not have a PK/UNIQUE index on the parent table.
</div>


<div>
I don't really need to reference a foreign key. I have created the table Recipes (the first SQL statement). Now I want to create a table MealPlans (the second SQL statement) and I want to put the constraint that RecipeID in MealPlans must be a RecipeID found in Recipes (hence the Many-To-Many relationship).<br />

<pre><code class="code-1 nolinks" id="code-262822"><span>CREATE TABLE Recipes(ID INTEGER, RecipeName CHAR(50) NOT NULL, IngredientID INTEGER NOT NULL, IngredientAmount FLOAT, PRIMARY KEY(ID, IngredientID), FOREIGN KEY(IngredientID) REFERENCES Ingredients(ID))</span>
<span> </span>
<span>CREATE TABLE MealPlans(ID Integer, MealPlanName CHAR(50) NOT NULL, RecipeID INTEGER, PRIMARY KEY(ID, RecipeID)</span>
</code></pre>
</div>


<div>
Ok. &nbsp;You want a foreign key for that with recipeid referencing recipies.id<br />
<br />
<br />
alter table MealPlans<br />
add constraint FK_MealPlans_Recipe <br />
foreign key (RecipeId) <br />
references Recipes (ID)<br />
<br />
That's not really a MANY TO MANY since each MealPlans.ID will only reference ONE and only ONE Recipes (according to your data model.
</div>


<div>
I figured as much. I know that the construction of the Recipes table is not the best (I should have a definition table too), just thought I would cut down on tables since this is an embedded db. But you're right I shouldn't be taking shortcuts like this (storing name multiple times is no good).
</div>


<div>
<div class="content wysiwyg-content">
Is it possible to create a table which has a column (A) which references a column (B) in another table which is not a key. I want to make sure that each value in A contains a value found in B. I suppose a many-to-many relationship. <br />
<br />
I have done this in MS Access before but I'm not sure how to construct the SQL statement to create the table. I tried using foreign key, which didn't work because B is not a key.
</div>
</div>


Is it possible to create a table which has a column (A) which references a column (B) in another table which is not a key. I want to make sure that each value in A contains a value found in B. I suppose a many-to-many relationship. 

I have done this in MS Access before but I'm not sure how to construct the SQL statement to create the table. I tried using foreign key, which didn't work because B is not a key.

Reference a non-keyed column

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.